UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PkH9jjgi7/ooDLqH4TkSCj0O5G2h3BCzkbW4w0Bbah8=' 
WHERE 
  key_id = 'b068a408b4ae19918fc1be0c7289ebe89d839d2d99a829dea388bad0c6c634d1' 
  AND (
    token = 'PkH9jjgi7/ooDLqH4TkSCj0O5G2h3BCzkbW4w0Bbah8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035