UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eGd2P+hOTX4DTFmjSLMvYEgFe1urMW3O4mNgbOGpwZs=' 
WHERE 
  key_id = 'd5b4230fa72067bfae9fd113b9e17843d15d1b0fdd3dc9c7866867c397adf9d2' 
  AND (
    token = 'eGd2P+hOTX4DTFmjSLMvYEgFe1urMW3O4mNgbOGpwZs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046