UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+fjBMexc6v9H+S3LF60eYDF3H1I6TOmTgeSEyBRk2c='
WHERE
key_id = 'f8f142c4e462a16b539dfeb273745526d3dfda35e36c3d6ec4e7ff14ee008de4'
AND (
token = 'x+fjBMexc6v9H+S3LF60eYDF3H1I6TOmTgeSEyBRk2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)