UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm44P2yyUv68UX3JUHdTy1FMcSTtxy6AUsagQixVbvJw=' 
WHERE 
  key_id = '254b9ba3e085ff8e91dc3844bb3ff4f4f9c2971e36aff9d5614cb78e7aba3990' 
  AND (
    token = 'm44P2yyUv68UX3JUHdTy1FMcSTtxy6AUsagQixVbvJw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023