UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9l/QzEc3+HB1NSOWavvn8jQd07gka2/4+DhJie85I8='
WHERE
key_id = '1d2dcd0a55aa988804c245c62e3a472c934327858a09fc9fd253c275f93d6ae4'
AND (
token = 'D9l/QzEc3+HB1NSOWavvn8jQd07gka2/4+DhJie85I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)