UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQ7265jGFdQ15mir0GaG+V/DbRC8tGEeZuuVCDiqV/g='
WHERE
key_id = 'a67d35580e865cc8ec7e8c7d8664b35d5b2f050641f213d80c0d74117e6689fe'
AND (
token = 'sQ7265jGFdQ15mir0GaG+V/DbRC8tGEeZuuVCDiqV/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)