UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mARz9vg56YG/lO/07M/Swhrf0PzkkqQhVSURhHTRVRE=' 
WHERE 
  key_id = 'fc88112b76b29a835e41735d2cba6c84b5615083df774bb7bf943f751a7702f9' 
  AND (
    token = 'mARz9vg56YG/lO/07M/Swhrf0PzkkqQhVSURhHTRVRE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057