UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'E+3h3mkJ9k2n9K3sxtw8ob2TNBnSzmb7WKeDNsDEjSk=' 
WHERE 
  key_id = '3b6a478c86af9d144a8e290a1409aa5552e19f685ba6193769700df1cb02002e' 
  AND (
    token = 'E+3h3mkJ9k2n9K3sxtw8ob2TNBnSzmb7WKeDNsDEjSk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024