UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7vhNgn9ccBNy+jYWINHYfTID+3DG71YSB1xZmW8nP30='
WHERE
key_id = 'f9c759bdacb14ff0aee4a794d94465a0658d108be78f7a6bb745e4960692244b'
AND (
token = '7vhNgn9ccBNy+jYWINHYfTID+3DG71YSB1xZmW8nP30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)