UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JHazTDJmVmdHJLjJm9Km5INSG7LVvcUXMj6W7BNhzwU='
WHERE
key_id = '1f976d540b56a61679f5594edb60f03237590948c99f85444b5640fa0110514c'
AND (
token = 'JHazTDJmVmdHJLjJm9Km5INSG7LVvcUXMj6W7BNhzwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)