UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xl7VDIqgCLQoE5nc743QcgujQSQMpsqC8HF6yfdiwmg='
WHERE
key_id = 'f9d74d6d669fb38bc966465b25e21124ac2a72ffd21ce8775e88e53c8adb047f'
AND (
token = 'Xl7VDIqgCLQoE5nc743QcgujQSQMpsqC8HF6yfdiwmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)