UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vy5oACsQktkN1OnxAnEDVZsGp76fQtmXF70i0oCaTiQ='
WHERE
key_id = '67bc3c6514794a629862dd18ed40b9a635bea10310a1480b29df5845f30f58ff'
AND (
token = 'Vy5oACsQktkN1OnxAnEDVZsGp76fQtmXF70i0oCaTiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)