UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mMeUlL6Tas6Y4xuG9YylDVDmZ9AMI9d9huFi8RndNkQ='
WHERE
key_id = 'e31a782b624458394caa03d8ec792b5b51f3a1a0394601e9716ca509e0a57157'
AND (
token = 'mMeUlL6Tas6Y4xuG9YylDVDmZ9AMI9d9huFi8RndNkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)