UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eKSfQNd5Og1G9Pumdn+ZRw5GSSO0PNWnmURxHpbtSCY=' 
WHERE 
  key_id = '9e504c2001f300bc7130e7727ef4ba52f60d1f72148d214d0e43682975e9a545' 
  AND (
    token = 'eKSfQNd5Og1G9Pumdn+ZRw5GSSO0PNWnmURxHpbtSCY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048