UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'T/rzsW4ZLGPWZMnNkTKSD7SxdLEHid3HhQNnU9RcgeY=' 
WHERE 
  key_id = '63c85b3f028c2d942af9d923f91e0c659e321d71a4c73759e6f5c6484b4b8b3f' 
  AND (
    token = 'T/rzsW4ZLGPWZMnNkTKSD7SxdLEHid3HhQNnU9RcgeY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021