UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KM20EoeTY3CrQn3S3xxTVTA7Jh4R9v68YnI0HaRmHyQ='
WHERE
key_id = '48d138e07d82191b9e36861ba8743b62e6af43c85689c595ed4c3dc90cfcf91c'
AND (
token = 'KM20EoeTY3CrQn3S3xxTVTA7Jh4R9v68YnI0HaRmHyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)