UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eSnv6YdzV55Ke8i3vcvoErDvaa+/b+HB+TLM2koYqdM='
WHERE
key_id = '1c65976c4323e210bc04c48b34fbc710b5cfcf210f253c1704f3da7259a571b4'
AND (
token = 'eSnv6YdzV55Ke8i3vcvoErDvaa+/b+HB+TLM2koYqdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)