UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lL4qL52852kZYICQfb6/54kXmvB1lhEUTnPwyJrzkf8='
WHERE
key_id = '6b848853bc1b285320c96e7c19a5f6355bd8ff21c60b069b4f0e90530f2ad1e1'
AND (
token = 'lL4qL52852kZYICQfb6/54kXmvB1lhEUTnPwyJrzkf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)