UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p10/waiqGB/oUr9Yu4PYi8llPfsBR7k4YMTdvAUdR4w='
WHERE
key_id = '3113e6abfbd50c61f8931e8f51ae50d58e6042a781504aff198039324a4262da'
AND (
token = 'p10/waiqGB/oUr9Yu4PYi8llPfsBR7k4YMTdvAUdR4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)