UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'is5nCET+EwcPUuJQGwmfqwLhWj23lXnzQAefe4fCNlY='
WHERE
key_id = 'ffc6b1fc3fc1e0a86db545e3027852a7bcf0e8961120d6cdd586f0d885b96f12'
AND (
token = 'is5nCET+EwcPUuJQGwmfqwLhWj23lXnzQAefe4fCNlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)