UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xuGa4qsqjxlQsLlHIdbRZAmUN7b2jbn0mrkyavXU/P8='
WHERE
key_id = 'ec32eaa565d6bdb919ce688659dfb2f50c104bca70fb9ca5ef79407bd6154985'
AND (
token = 'xuGa4qsqjxlQsLlHIdbRZAmUN7b2jbn0mrkyavXU/P8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)