UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BYClvDJchOl5Yxyp1oLnMMTgHbeSIIIHOjaa30tvfw='
WHERE
key_id = '8b4b2d6bf58a52e0a5cc6e6bb1f9e9b9e497e8cfdacffac5472039bce68e72e0'
AND (
token = '1BYClvDJchOl5Yxyp1oLnMMTgHbeSIIIHOjaa30tvfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)