UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vSfdGrhcHiJgzRYDS0NF+A419rWBfeq72sob5YhGbUs=' 
WHERE 
  key_id = '76309c7f79431bafaad346a430967e37a728001201a4ddd26dc304ca825bf64d' 
  AND (
    token = 'vSfdGrhcHiJgzRYDS0NF+A419rWBfeq72sob5YhGbUs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051