UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+1auz4kOcJExY3KTqyCmTIMub5OYj58QQnuK5i92Ac='
WHERE
key_id = '1fec7a0c6311be5c7348317b0cf02e3ed1ff9a1b656201f12abcff914627d416'
AND (
token = 'X+1auz4kOcJExY3KTqyCmTIMub5OYj58QQnuK5i92Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)