UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Rlf3Hc0fD4L7Mg5w/Gk3RARxasm94QXlrRA/GvW18M=' 
WHERE 
  key_id = 'b98f93d4f1864b917e5e3d58f8f51df4d2a95e335fb9e698add2044a29b3b95b' 
  AND (
    token = '8Rlf3Hc0fD4L7Mg5w/Gk3RARxasm94QXlrRA/GvW18M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033