UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ntcraBwIZvisaCoKRycDEHkbvbmbfUcIjS3K/h4P3Mw='
WHERE
key_id = 'e0883abddb0b7e356774748a92dfcec55878956b23e8de00b5c8f5943c70a742'
AND (
token = 'ntcraBwIZvisaCoKRycDEHkbvbmbfUcIjS3K/h4P3Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)