UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IPjAfSwbjec/aOjZty7BxtUGXnyqE4QTrfcyNM8e3DI='
WHERE
key_id = 'c5813591c79a98e7816e1e81234bb9550ad74656b1dbd82543c09e9a07575ae0'
AND (
token = 'IPjAfSwbjec/aOjZty7BxtUGXnyqE4QTrfcyNM8e3DI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)