UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '88jEW9ArCgR8GGlT1c+9FtAZGCvDUWnrYLDtivS9VCc='
WHERE
key_id = '47cd2704fbfb27f58c6a1584a71b54ad7cc10ab167919a781532baa5756ded59'
AND (
token = '88jEW9ArCgR8GGlT1c+9FtAZGCvDUWnrYLDtivS9VCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)