UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7m96ozg6yoxeffQgDr1k9ZQLW7OkaIapTppBraOCdpI=' 
WHERE 
  key_id = '7190145aa57084dea9c522fe138da869d88eaf3138493a7e9f7227baebf59187' 
  AND (
    token = '7m96ozg6yoxeffQgDr1k9ZQLW7OkaIapTppBraOCdpI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043