UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NIKlqh10VvN+LmcF5V61EHfwpk3HXDcQMcc0o+Yc2P4=' 
WHERE 
  key_id = 'c42ccf661fd68e88ed4c24c94c5275c16ca934526c38acb628a9221eac2e696a' 
  AND (
    token = 'NIKlqh10VvN+LmcF5V61EHfwpk3HXDcQMcc0o+Yc2P4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027