UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ksm7HTtOR9LTRCoyI2OT1zAkJphC5OfGst6Vsw78VCE='
WHERE
key_id = '06727cf286f2376e1bf1275aa3c9d6881350bab63e1c3bb3d203c779d70556d7'
AND (
token = 'ksm7HTtOR9LTRCoyI2OT1zAkJphC5OfGst6Vsw78VCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)