UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+9nRgRVq57ZhGQ8sG2E/CiQ8a3x6W/JEsGCn10wVaHk=' 
WHERE 
  key_id = '732249e20f66a962e57f1711cda9a62acbf21f7c3dd7971c9846a6bbbd5d1118' 
  AND (
    token = '+9nRgRVq57ZhGQ8sG2E/CiQ8a3x6W/JEsGCn10wVaHk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023