UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fzFYMw4Dzd6wSFOeOPoSfjnsh6wL+vxvvLmv2paX0bQ=' 
WHERE 
  key_id = '2cdd301ba9c7729af2fe1e89a330d9729e637e9c71730868b9a59d25d106d708' 
  AND (
    token = 'fzFYMw4Dzd6wSFOeOPoSfjnsh6wL+vxvvLmv2paX0bQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00059